OpenBots Command group containing Microsoft Interop commands (Excel, Outlook, Word).
OpenBots.Commands.Microsoft \ Excel Split Range By Column Command
This command takes a specific Excel range, splits it into separate ranges by column, and stores them in new Workbooks.
Excel Instance Name
Enter the unique instance that was specified in the **Create Application** command.
Required
Range
Enter the location of the range to split.
Required
Column to Split
Enter the name of the column you wish to split the selected range by.
Required
Split Range Output Directory
Enter or Select the new directory for the split range files.
Required
Output File Type
Specify the file format type for the split range files.
Required
Output DataTable List Variable
Create a new variable or select a variable from the list.
Required
Private (Optional)
Optional field to mark the command as private (data sensitive) in order to avoid its logging.
Comment Field (Optional)
Optional field to enter a custom comment which could potentially describe this command or the need for this command, if required.
Other Commands
Word Append Data Table Command
Word Close Application Command
Word Create Application Command
Get Outlook Email Property Command
Move Copy Outlook Email Command
Reply To Outlook Email Command
Excel Close Application Command
Excel Create Application Command
Excel Get Last Row Index Command
Excel Save Workbook As Command